{
 "cells": [
  {
   "cell_type": "code",
   "id": "initial_id",
   "metadata": {
    "collapsed": true,
    "ExecuteTime": {
     "end_time": "2024-05-20T08:11:54.981363Z",
     "start_time": "2024-05-20T08:11:52.117768Z"
    }
   },
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sn"
   ],
   "outputs": [],
   "execution_count": 1
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-20T08:37:41.487904Z",
     "start_time": "2024-05-20T08:37:41.456318Z"
    }
   },
   "cell_type": "code",
   "source": [
    "data = pd.read_csv('house.csv')\n",
    "data"
   ],
   "id": "ba1e8d9a57479cc1",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "           address areaSize   price                           title\n",
       "0      朝阳高碑店高碑店村东区     650㎡   30000        国贸东 高碑店精装会所 好位置 停车方便 能注册\n",
       "1        海淀西山颐和金茂府     210㎡   46000          颐和金茂府 4室2厅3卫 品质小区 主卧朝南\n",
       "2       海淀万柳锋尚国际公寓     110㎡   17300  万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错\n",
       "3         丰台岳各庄大成郡     135㎡   13800                出租 大成郡 3室 南北 精装修\n",
       "4   朝阳朝阳公园朝阳公园西里北区      46㎡    6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居\n",
       "5      朝阳豆各庄青荷里晨风园      60㎡    4200    青荷里晨风园 2室1卫1厅 60平精装修 4200元/月\n",
       "6   朝阳朝阳公园朝阳公园西里北区      61㎡    6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居\n",
       "7        西城广安门京铁和园      35㎡    4600     白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住\n",
       "8    丰台看丹桥造甲街南里5号院      60㎡    6000         全新自住装修造甲街南里6000块钱南北通透两居\n",
       "9       大兴亦庄君安国际公寓     147㎡   11000  君安国际公寓 3室2卫2厅 147平精装修 12000元/月\n",
       "10        海淀西山西山美庐     357㎡  110000      西山豪华大独栋 豪华装修 家具齐全 商务接待设施齐全\n",
       "11      朝阳朝青南太平庄北巷      20㎡    2260        相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧\n",
       "12       朝阳朝阳公园博雅园     169㎡   23000  博雅园可观高尔夫球场全景,视野开阔,开放式厨房,业主诚意出租\n",
       "13      大兴亦庄君安国际公寓     107㎡    7500        实景实价 君安和国际 两居两卫 空房出租 随时看\n",
       "14        海淀公主坟国悦府      96㎡   19000             国悦府 1室1厅1卫 带飘窗 经典实用\n",
       "15        朝阳燕莎亮马名居     115㎡   14000    朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全\n",
       "16      顺义中央别墅区誉天下     383㎡   23000            誉天下 5室3厅4卫 格局方正 品质小区\n",
       "17      朝阳朝阳公园枣营南里      58㎡    7500       朝阳公园 麦子店枣营南里精装双南向 两居室 随时住\n",
       "18        丰台洋桥海户西里      85㎡    2860  三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍\n",
       "19     丰台玉泉营万年花城一期      18㎡    2330  首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租\n",
       "20      房山房山城关福胜家园      87㎡    2200    房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费\n",
       "21      丰台赵公口彩虹城四区      52㎡    4800            相寓 赵公口·彩虹城四区·低楼层·1居室\n",
       "22  房山房山城关中国铁建原香漫谷      88㎡    2800       整租 · 房山城关 · 原香漫谷三区 · 3室1厅\n",
       "23   顺义中央别墅区中铁诺德阅墅     301㎡   26000   诺德首套房出租,南端户守次出租,现代简约风格 新风地暖具备\n",
       "24        海淀公主坟颐源居     159㎡   21000       颐源居 房子干净整洁 视野开阔 条件可谈 看房方便\n",
       "25     海淀世纪城世纪城晴雪园     164㎡   25000  价格可大谈!世纪城晴雪园 南北通透 精装修人车分流 业主急租\n",
       "26      朝阳百子湾沿海赛洛城     103㎡   10500      地铁7号线!急租三居室!南北通透!采光充足!随时看房\n",
       "27        房山长阳长阳半岛      86㎡    4600   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖\n",
       "28        丰台岳各庄大成郡     229㎡   28000      出租 五棵松 丽泽商务区 大成郡 3室 南北 精装修\n",
       "29       房山长阳首创新悦都      75㎡    4300        整租 · 长阳 · 首创新悦都二区 · 2室1厅\n",
       "30      怀柔怀柔城区美丽家园      91㎡    2000          南北通透 美丽家园 2室1厅 2000元/月\n",
       "31      海淀万柳光大水墨风景      97㎡   18000  万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室\n",
       "32        海淀世纪城上河村     323㎡   55000        鲁艺上河村三期 5室2厅3卫 主卧朝南 两房朝南\n",
       "33     怀柔怀柔城区南华园四区      87㎡    2400  南华园四区 2室1卫2厅 87.03平简装修 2400元/月\n",
       "34     房山长阳首开熙悦山澜庭      90㎡    5000   长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖\n",
       "35        房山长阳长阳半岛      86㎡    4700   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖\n",
       "36      朝阳百子湾沿海赛洛城      69㎡    6300       可!看房随时!东西一居室!价格可砍!高层!采光充足\n",
       "37       丰台岳各庄万科紫台     173㎡   14000               出租 万科紫台 3室 南北 精装修\n",
       "38     房山长阳首开熙悦山澜庭      83㎡    5200          整租 · 长阳 · 熙悦山南区 · 2室1厅\n",
       "39      丰台青塔首创天阅山河     135㎡   11000             出租 首创天阅山河 3室 南北 精装修\n",
       "40      朝阳百子湾沿海赛洛城      97㎡    8200                    国贸 双井 南北通透两居\n",
       "41        海淀公主坟国悦府     373㎡   66000        国悦府 长安街 南北通透四居 空房出租 车位充足\n",
       "42        海淀世纪城时雨园     167㎡   17300       世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南\n",
       "43    海淀公主坟新华联国际公寓     274㎡   58000     新华联国际公寓 南北4居 百平客厅 一梯一户 车位充足\n",
       "44      西城牛街牛街西里二区      55㎡   14000      新出牛街西里二区 3室 精装修+有电梯+近地铁+超市\n",
       "45     西城广安门荣丰2008      32㎡    3800              出租 荣丰2008 1室 南 简装修\n",
       "46     西城广安门荣丰2008      25㎡    3900              出租 荣丰2008 1室 北 简装修\n",
       "47    海淀公主坟新华联国际公寓     293㎡   63000  新华联国际公寓 边户观西山 新装修 保养好 一梯一户 有车位\n",
       "48     房山长阳首开熙悦山澜庭      74㎡    4500          整租 · 长阳 · 熙悦山南区 · 2室1厅\n",
       "49    海淀公主坟新华联国际公寓     275㎡   55000     新华联国际公寓 南北4居 百平客厅 一梯一户 车位充足\n",
       "50      海淀万柳光大水墨风景     151㎡   27000   万柳商圈 光大水墨风景 万城小华府 主力南北通透三居室户型\n",
       "51        丰台青塔福悦四季      40㎡    4200  地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房\n",
       "52      怀柔怀柔城区湖光小区      53㎡    2300   湖光小区 2室1卫1厅 53.04平简装修 2300元/月\n",
       "53   海淀世纪城世纪城三期翠叠园     127㎡   15300  新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!\n",
       "54     怀柔怀柔城区金台园小区      74㎡    2400                南北通透金台园小区3室1厅精装修\n",
       "55     房山长阳首开熙悦山澜庭      90㎡    4800          整租 · 长阳 · 熙悦山南区 · 2室1厅\n",
       "56     西城广安门玺源台·承玺      32㎡    5800             出租 玺源台·承玺 1室 南向 简装修\n",
       "57     西城广安门荣丰2008      24㎡    4100              出租 荣丰2008 1室 北 简装修\n",
       "58       西城广安门远见名苑      57㎡    5500                出租 远见名苑 1室 西 简装修\n",
       "59       怀柔雁栖世嘉光织谷      95㎡    2300                     正南世嘉光织谷2室2厅"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>areaSize</th>\n",
       "      <th>price</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>朝阳高碑店高碑店村东区</td>\n",
       "      <td>650㎡</td>\n",
       "      <td>30000</td>\n",
       "      <td>国贸东 高碑店精装会所 好位置 停车方便 能注册</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>海淀西山颐和金茂府</td>\n",
       "      <td>210㎡</td>\n",
       "      <td>46000</td>\n",
       "      <td>颐和金茂府 4室2厅3卫 品质小区 主卧朝南</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>海淀万柳锋尚国际公寓</td>\n",
       "      <td>110㎡</td>\n",
       "      <td>17300</td>\n",
       "      <td>万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>丰台岳各庄大成郡</td>\n",
       "      <td>135㎡</td>\n",
       "      <td>13800</td>\n",
       "      <td>出租 大成郡 3室 南北 精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>46㎡</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>朝阳豆各庄青荷里晨风园</td>\n",
       "      <td>60㎡</td>\n",
       "      <td>4200</td>\n",
       "      <td>青荷里晨风园 2室1卫1厅 60平精装修 4200元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>61㎡</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>西城广安门京铁和园</td>\n",
       "      <td>35㎡</td>\n",
       "      <td>4600</td>\n",
       "      <td>白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>丰台看丹桥造甲街南里5号院</td>\n",
       "      <td>60㎡</td>\n",
       "      <td>6000</td>\n",
       "      <td>全新自住装修造甲街南里6000块钱南北通透两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>147㎡</td>\n",
       "      <td>11000</td>\n",
       "      <td>君安国际公寓 3室2卫2厅 147平精装修 12000元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>海淀西山西山美庐</td>\n",
       "      <td>357㎡</td>\n",
       "      <td>110000</td>\n",
       "      <td>西山豪华大独栋 豪华装修 家具齐全 商务接待设施齐全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>朝阳朝青南太平庄北巷</td>\n",
       "      <td>20㎡</td>\n",
       "      <td>2260</td>\n",
       "      <td>相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>朝阳朝阳公园博雅园</td>\n",
       "      <td>169㎡</td>\n",
       "      <td>23000</td>\n",
       "      <td>博雅园可观高尔夫球场全景,视野开阔,开放式厨房,业主诚意出租</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>107㎡</td>\n",
       "      <td>7500</td>\n",
       "      <td>实景实价 君安和国际 两居两卫 空房出租 随时看</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>海淀公主坟国悦府</td>\n",
       "      <td>96㎡</td>\n",
       "      <td>19000</td>\n",
       "      <td>国悦府 1室1厅1卫 带飘窗 经典实用</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>朝阳燕莎亮马名居</td>\n",
       "      <td>115㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>顺义中央别墅区誉天下</td>\n",
       "      <td>383㎡</td>\n",
       "      <td>23000</td>\n",
       "      <td>誉天下 5室3厅4卫 格局方正 品质小区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>朝阳朝阳公园枣营南里</td>\n",
       "      <td>58㎡</td>\n",
       "      <td>7500</td>\n",
       "      <td>朝阳公园 麦子店枣营南里精装双南向 两居室 随时住</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>丰台洋桥海户西里</td>\n",
       "      <td>85㎡</td>\n",
       "      <td>2860</td>\n",
       "      <td>三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>丰台玉泉营万年花城一期</td>\n",
       "      <td>18㎡</td>\n",
       "      <td>2330</td>\n",
       "      <td>首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>房山房山城关福胜家园</td>\n",
       "      <td>87㎡</td>\n",
       "      <td>2200</td>\n",
       "      <td>房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>丰台赵公口彩虹城四区</td>\n",
       "      <td>52㎡</td>\n",
       "      <td>4800</td>\n",
       "      <td>相寓 赵公口·彩虹城四区·低楼层·1居室</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>房山房山城关中国铁建原香漫谷</td>\n",
       "      <td>88㎡</td>\n",
       "      <td>2800</td>\n",
       "      <td>整租 · 房山城关 · 原香漫谷三区 · 3室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>顺义中央别墅区中铁诺德阅墅</td>\n",
       "      <td>301㎡</td>\n",
       "      <td>26000</td>\n",
       "      <td>诺德首套房出租,南端户守次出租,现代简约风格 新风地暖具备</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>海淀公主坟颐源居</td>\n",
       "      <td>159㎡</td>\n",
       "      <td>21000</td>\n",
       "      <td>颐源居 房子干净整洁 视野开阔 条件可谈 看房方便</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>海淀世纪城世纪城晴雪园</td>\n",
       "      <td>164㎡</td>\n",
       "      <td>25000</td>\n",
       "      <td>价格可大谈!世纪城晴雪园 南北通透 精装修人车分流 业主急租</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>103㎡</td>\n",
       "      <td>10500</td>\n",
       "      <td>地铁7号线!急租三居室!南北通透!采光充足!随时看房</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86㎡</td>\n",
       "      <td>4600</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>丰台岳各庄大成郡</td>\n",
       "      <td>229㎡</td>\n",
       "      <td>28000</td>\n",
       "      <td>出租 五棵松 丽泽商务区 大成郡 3室 南北 精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>房山长阳首创新悦都</td>\n",
       "      <td>75㎡</td>\n",
       "      <td>4300</td>\n",
       "      <td>整租 · 长阳 · 首创新悦都二区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>怀柔怀柔城区美丽家园</td>\n",
       "      <td>91㎡</td>\n",
       "      <td>2000</td>\n",
       "      <td>南北通透 美丽家园 2室1厅 2000元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>海淀万柳光大水墨风景</td>\n",
       "      <td>97㎡</td>\n",
       "      <td>18000</td>\n",
       "      <td>万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>海淀世纪城上河村</td>\n",
       "      <td>323㎡</td>\n",
       "      <td>55000</td>\n",
       "      <td>鲁艺上河村三期 5室2厅3卫 主卧朝南 两房朝南</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>怀柔怀柔城区南华园四区</td>\n",
       "      <td>87㎡</td>\n",
       "      <td>2400</td>\n",
       "      <td>南华园四区 2室1卫2厅 87.03平简装修 2400元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90㎡</td>\n",
       "      <td>5000</td>\n",
       "      <td>长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86㎡</td>\n",
       "      <td>4700</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>69㎡</td>\n",
       "      <td>6300</td>\n",
       "      <td>可!看房随时!东西一居室!价格可砍!高层!采光充足</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>丰台岳各庄万科紫台</td>\n",
       "      <td>173㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>出租 万科紫台 3室 南北 精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>83㎡</td>\n",
       "      <td>5200</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>丰台青塔首创天阅山河</td>\n",
       "      <td>135㎡</td>\n",
       "      <td>11000</td>\n",
       "      <td>出租 首创天阅山河 3室 南北 精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>97㎡</td>\n",
       "      <td>8200</td>\n",
       "      <td>国贸 双井 南北通透两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>海淀公主坟国悦府</td>\n",
       "      <td>373㎡</td>\n",
       "      <td>66000</td>\n",
       "      <td>国悦府 长安街 南北通透四居 空房出租 车位充足</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>海淀世纪城时雨园</td>\n",
       "      <td>167㎡</td>\n",
       "      <td>17300</td>\n",
       "      <td>世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>海淀公主坟新华联国际公寓</td>\n",
       "      <td>274㎡</td>\n",
       "      <td>58000</td>\n",
       "      <td>新华联国际公寓 南北4居 百平客厅 一梯一户 车位充足</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>西城牛街牛街西里二区</td>\n",
       "      <td>55㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>新出牛街西里二区 3室 精装修+有电梯+近地铁+超市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>32㎡</td>\n",
       "      <td>3800</td>\n",
       "      <td>出租 荣丰2008 1室 南 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>25㎡</td>\n",
       "      <td>3900</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>海淀公主坟新华联国际公寓</td>\n",
       "      <td>293㎡</td>\n",
       "      <td>63000</td>\n",
       "      <td>新华联国际公寓 边户观西山 新装修 保养好 一梯一户 有车位</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>74㎡</td>\n",
       "      <td>4500</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>海淀公主坟新华联国际公寓</td>\n",
       "      <td>275㎡</td>\n",
       "      <td>55000</td>\n",
       "      <td>新华联国际公寓 南北4居 百平客厅 一梯一户 车位充足</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>海淀万柳光大水墨风景</td>\n",
       "      <td>151㎡</td>\n",
       "      <td>27000</td>\n",
       "      <td>万柳商圈 光大水墨风景 万城小华府 主力南北通透三居室户型</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>丰台青塔福悦四季</td>\n",
       "      <td>40㎡</td>\n",
       "      <td>4200</td>\n",
       "      <td>地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>怀柔怀柔城区湖光小区</td>\n",
       "      <td>53㎡</td>\n",
       "      <td>2300</td>\n",
       "      <td>湖光小区 2室1卫1厅 53.04平简装修 2300元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>海淀世纪城世纪城三期翠叠园</td>\n",
       "      <td>127㎡</td>\n",
       "      <td>15300</td>\n",
       "      <td>新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>怀柔怀柔城区金台园小区</td>\n",
       "      <td>74㎡</td>\n",
       "      <td>2400</td>\n",
       "      <td>南北通透金台园小区3室1厅精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90㎡</td>\n",
       "      <td>4800</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>西城广安门玺源台·承玺</td>\n",
       "      <td>32㎡</td>\n",
       "      <td>5800</td>\n",
       "      <td>出租 玺源台·承玺 1室 南向 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>24㎡</td>\n",
       "      <td>4100</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>西城广安门远见名苑</td>\n",
       "      <td>57㎡</td>\n",
       "      <td>5500</td>\n",
       "      <td>出租 远见名苑 1室 西 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>怀柔雁栖世嘉光织谷</td>\n",
       "      <td>95㎡</td>\n",
       "      <td>2300</td>\n",
       "      <td>正南世嘉光织谷2室2厅</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 33
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-20T08:37:44.244146Z",
     "start_time": "2024-05-20T08:37:44.215519Z"
    }
   },
   "cell_type": "code",
   "source": [
    "cond1 = data[\"price\"] <= 20000\n",
    "data = data[cond1]\n",
    "data"
   ],
   "id": "ef7580a218486e2a",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "           address areaSize  price                           title\n",
       "2       海淀万柳锋尚国际公寓     110㎡  17300  万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错\n",
       "3         丰台岳各庄大成郡     135㎡  13800                出租 大成郡 3室 南北 精装修\n",
       "4   朝阳朝阳公园朝阳公园西里北区      46㎡   6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居\n",
       "5      朝阳豆各庄青荷里晨风园      60㎡   4200    青荷里晨风园 2室1卫1厅 60平精装修 4200元/月\n",
       "6   朝阳朝阳公园朝阳公园西里北区      61㎡   6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居\n",
       "7        西城广安门京铁和园      35㎡   4600     白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住\n",
       "8    丰台看丹桥造甲街南里5号院      60㎡   6000         全新自住装修造甲街南里6000块钱南北通透两居\n",
       "9       大兴亦庄君安国际公寓     147㎡  11000  君安国际公寓 3室2卫2厅 147平精装修 12000元/月\n",
       "11      朝阳朝青南太平庄北巷      20㎡   2260        相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧\n",
       "13      大兴亦庄君安国际公寓     107㎡   7500        实景实价 君安和国际 两居两卫 空房出租 随时看\n",
       "14        海淀公主坟国悦府      96㎡  19000             国悦府 1室1厅1卫 带飘窗 经典实用\n",
       "15        朝阳燕莎亮马名居     115㎡  14000    朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全\n",
       "17      朝阳朝阳公园枣营南里      58㎡   7500       朝阳公园 麦子店枣营南里精装双南向 两居室 随时住\n",
       "18        丰台洋桥海户西里      85㎡   2860  三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍\n",
       "19     丰台玉泉营万年花城一期      18㎡   2330  首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租\n",
       "20      房山房山城关福胜家园      87㎡   2200    房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费\n",
       "21      丰台赵公口彩虹城四区      52㎡   4800            相寓 赵公口·彩虹城四区·低楼层·1居室\n",
       "22  房山房山城关中国铁建原香漫谷      88㎡   2800       整租 · 房山城关 · 原香漫谷三区 · 3室1厅\n",
       "26      朝阳百子湾沿海赛洛城     103㎡  10500      地铁7号线!急租三居室!南北通透!采光充足!随时看房\n",
       "27        房山长阳长阳半岛      86㎡   4600   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖\n",
       "29       房山长阳首创新悦都      75㎡   4300        整租 · 长阳 · 首创新悦都二区 · 2室1厅\n",
       "30      怀柔怀柔城区美丽家园      91㎡   2000          南北通透 美丽家园 2室1厅 2000元/月\n",
       "31      海淀万柳光大水墨风景      97㎡  18000  万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室\n",
       "33     怀柔怀柔城区南华园四区      87㎡   2400  南华园四区 2室1卫2厅 87.03平简装修 2400元/月\n",
       "34     房山长阳首开熙悦山澜庭      90㎡   5000   长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖\n",
       "35        房山长阳长阳半岛      86㎡   4700   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖\n",
       "36      朝阳百子湾沿海赛洛城      69㎡   6300       可!看房随时!东西一居室!价格可砍!高层!采光充足\n",
       "37       丰台岳各庄万科紫台     173㎡  14000               出租 万科紫台 3室 南北 精装修\n",
       "38     房山长阳首开熙悦山澜庭      83㎡   5200          整租 · 长阳 · 熙悦山南区 · 2室1厅\n",
       "39      丰台青塔首创天阅山河     135㎡  11000             出租 首创天阅山河 3室 南北 精装修\n",
       "40      朝阳百子湾沿海赛洛城      97㎡   8200                    国贸 双井 南北通透两居\n",
       "42        海淀世纪城时雨园     167㎡  17300       世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南\n",
       "44      西城牛街牛街西里二区      55㎡  14000      新出牛街西里二区 3室 精装修+有电梯+近地铁+超市\n",
       "45     西城广安门荣丰2008      32㎡   3800              出租 荣丰2008 1室 南 简装修\n",
       "46     西城广安门荣丰2008      25㎡   3900              出租 荣丰2008 1室 北 简装修\n",
       "48     房山长阳首开熙悦山澜庭      74㎡   4500          整租 · 长阳 · 熙悦山南区 · 2室1厅\n",
       "51        丰台青塔福悦四季      40㎡   4200  地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房\n",
       "52      怀柔怀柔城区湖光小区      53㎡   2300   湖光小区 2室1卫1厅 53.04平简装修 2300元/月\n",
       "53   海淀世纪城世纪城三期翠叠园     127㎡  15300  新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!\n",
       "54     怀柔怀柔城区金台园小区      74㎡   2400                南北通透金台园小区3室1厅精装修\n",
       "55     房山长阳首开熙悦山澜庭      90㎡   4800          整租 · 长阳 · 熙悦山南区 · 2室1厅\n",
       "56     西城广安门玺源台·承玺      32㎡   5800             出租 玺源台·承玺 1室 南向 简装修\n",
       "57     西城广安门荣丰2008      24㎡   4100              出租 荣丰2008 1室 北 简装修\n",
       "58       西城广安门远见名苑      57㎡   5500                出租 远见名苑 1室 西 简装修\n",
       "59       怀柔雁栖世嘉光织谷      95㎡   2300                     正南世嘉光织谷2室2厅"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>areaSize</th>\n",
       "      <th>price</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>海淀万柳锋尚国际公寓</td>\n",
       "      <td>110㎡</td>\n",
       "      <td>17300</td>\n",
       "      <td>万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>丰台岳各庄大成郡</td>\n",
       "      <td>135㎡</td>\n",
       "      <td>13800</td>\n",
       "      <td>出租 大成郡 3室 南北 精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>46㎡</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>朝阳豆各庄青荷里晨风园</td>\n",
       "      <td>60㎡</td>\n",
       "      <td>4200</td>\n",
       "      <td>青荷里晨风园 2室1卫1厅 60平精装修 4200元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>61㎡</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>西城广安门京铁和园</td>\n",
       "      <td>35㎡</td>\n",
       "      <td>4600</td>\n",
       "      <td>白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>丰台看丹桥造甲街南里5号院</td>\n",
       "      <td>60㎡</td>\n",
       "      <td>6000</td>\n",
       "      <td>全新自住装修造甲街南里6000块钱南北通透两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>147㎡</td>\n",
       "      <td>11000</td>\n",
       "      <td>君安国际公寓 3室2卫2厅 147平精装修 12000元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>朝阳朝青南太平庄北巷</td>\n",
       "      <td>20㎡</td>\n",
       "      <td>2260</td>\n",
       "      <td>相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>107㎡</td>\n",
       "      <td>7500</td>\n",
       "      <td>实景实价 君安和国际 两居两卫 空房出租 随时看</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>海淀公主坟国悦府</td>\n",
       "      <td>96㎡</td>\n",
       "      <td>19000</td>\n",
       "      <td>国悦府 1室1厅1卫 带飘窗 经典实用</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>朝阳燕莎亮马名居</td>\n",
       "      <td>115㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>朝阳朝阳公园枣营南里</td>\n",
       "      <td>58㎡</td>\n",
       "      <td>7500</td>\n",
       "      <td>朝阳公园 麦子店枣营南里精装双南向 两居室 随时住</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>丰台洋桥海户西里</td>\n",
       "      <td>85㎡</td>\n",
       "      <td>2860</td>\n",
       "      <td>三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>丰台玉泉营万年花城一期</td>\n",
       "      <td>18㎡</td>\n",
       "      <td>2330</td>\n",
       "      <td>首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>房山房山城关福胜家园</td>\n",
       "      <td>87㎡</td>\n",
       "      <td>2200</td>\n",
       "      <td>房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>丰台赵公口彩虹城四区</td>\n",
       "      <td>52㎡</td>\n",
       "      <td>4800</td>\n",
       "      <td>相寓 赵公口·彩虹城四区·低楼层·1居室</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>房山房山城关中国铁建原香漫谷</td>\n",
       "      <td>88㎡</td>\n",
       "      <td>2800</td>\n",
       "      <td>整租 · 房山城关 · 原香漫谷三区 · 3室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>103㎡</td>\n",
       "      <td>10500</td>\n",
       "      <td>地铁7号线!急租三居室!南北通透!采光充足!随时看房</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86㎡</td>\n",
       "      <td>4600</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>房山长阳首创新悦都</td>\n",
       "      <td>75㎡</td>\n",
       "      <td>4300</td>\n",
       "      <td>整租 · 长阳 · 首创新悦都二区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>怀柔怀柔城区美丽家园</td>\n",
       "      <td>91㎡</td>\n",
       "      <td>2000</td>\n",
       "      <td>南北通透 美丽家园 2室1厅 2000元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>海淀万柳光大水墨风景</td>\n",
       "      <td>97㎡</td>\n",
       "      <td>18000</td>\n",
       "      <td>万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>怀柔怀柔城区南华园四区</td>\n",
       "      <td>87㎡</td>\n",
       "      <td>2400</td>\n",
       "      <td>南华园四区 2室1卫2厅 87.03平简装修 2400元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90㎡</td>\n",
       "      <td>5000</td>\n",
       "      <td>长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86㎡</td>\n",
       "      <td>4700</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>69㎡</td>\n",
       "      <td>6300</td>\n",
       "      <td>可!看房随时!东西一居室!价格可砍!高层!采光充足</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>丰台岳各庄万科紫台</td>\n",
       "      <td>173㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>出租 万科紫台 3室 南北 精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>83㎡</td>\n",
       "      <td>5200</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>丰台青塔首创天阅山河</td>\n",
       "      <td>135㎡</td>\n",
       "      <td>11000</td>\n",
       "      <td>出租 首创天阅山河 3室 南北 精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>97㎡</td>\n",
       "      <td>8200</td>\n",
       "      <td>国贸 双井 南北通透两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>海淀世纪城时雨园</td>\n",
       "      <td>167㎡</td>\n",
       "      <td>17300</td>\n",
       "      <td>世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>西城牛街牛街西里二区</td>\n",
       "      <td>55㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>新出牛街西里二区 3室 精装修+有电梯+近地铁+超市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>32㎡</td>\n",
       "      <td>3800</td>\n",
       "      <td>出租 荣丰2008 1室 南 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>25㎡</td>\n",
       "      <td>3900</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>74㎡</td>\n",
       "      <td>4500</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>丰台青塔福悦四季</td>\n",
       "      <td>40㎡</td>\n",
       "      <td>4200</td>\n",
       "      <td>地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>怀柔怀柔城区湖光小区</td>\n",
       "      <td>53㎡</td>\n",
       "      <td>2300</td>\n",
       "      <td>湖光小区 2室1卫1厅 53.04平简装修 2300元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>海淀世纪城世纪城三期翠叠园</td>\n",
       "      <td>127㎡</td>\n",
       "      <td>15300</td>\n",
       "      <td>新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>怀柔怀柔城区金台园小区</td>\n",
       "      <td>74㎡</td>\n",
       "      <td>2400</td>\n",
       "      <td>南北通透金台园小区3室1厅精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90㎡</td>\n",
       "      <td>4800</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>西城广安门玺源台·承玺</td>\n",
       "      <td>32㎡</td>\n",
       "      <td>5800</td>\n",
       "      <td>出租 玺源台·承玺 1室 南向 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>24㎡</td>\n",
       "      <td>4100</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>西城广安门远见名苑</td>\n",
       "      <td>57㎡</td>\n",
       "      <td>5500</td>\n",
       "      <td>出租 远见名苑 1室 西 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>怀柔雁栖世嘉光织谷</td>\n",
       "      <td>95㎡</td>\n",
       "      <td>2300</td>\n",
       "      <td>正南世嘉光织谷2室2厅</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 34
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-20T08:20:54.746796Z",
     "start_time": "2024-05-20T08:20:54.736945Z"
    }
   },
   "cell_type": "code",
   "source": "data.to_csv('house1.csv')",
   "id": "bdfc5ff50f34fc61",
   "outputs": [],
   "execution_count": 12
  },
  {
   "metadata": {},
   "cell_type": "markdown",
   "source": "",
   "id": "59524a488f12cbef"
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-20T08:41:12.300746Z",
     "start_time": "2024-05-20T08:41:12.286522Z"
    }
   },
   "cell_type": "code",
   "source": [
    "data1 = data.copy()\n",
    "data1[\"areaSize\"] = data[\"areaSize\"].apply(lambda x:int(x[0:-1]))\n",
    "data1[\"price\"] = data[\"price\"].apply(lambda x:int(x))"
   ],
   "id": "58d445fddb4cbd42",
   "outputs": [],
   "execution_count": 43
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-20T08:45:39.473807Z",
     "start_time": "2024-05-20T08:45:39.440044Z"
    }
   },
   "cell_type": "code",
   "source": [
    "data1.info()\n",
    "data1"
   ],
   "id": "a87bbddb91178cf1",
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 45 entries, 2 to 59\n",
      "Data columns (total 5 columns):\n",
      " #   Column    Non-Null Count  Dtype  \n",
      "---  ------    --------------  -----  \n",
      " 0   address   45 non-null     object \n",
      " 1   areaSize  45 non-null     int64  \n",
      " 2   price     45 non-null     int64  \n",
      " 3   title     45 non-null     object \n",
      " 4   perprice  45 non-null     float64\n",
      "dtypes: float64(1), int64(2), object(2)\n",
      "memory usage: 2.1+ KB\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "           address  areaSize  price                           title  \\\n",
       "2       海淀万柳锋尚国际公寓       110  17300  万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错   \n",
       "3         丰台岳各庄大成郡       135  13800                出租 大成郡 3室 南北 精装修   \n",
       "4   朝阳朝阳公园朝阳公园西里北区        46   6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居   \n",
       "5      朝阳豆各庄青荷里晨风园        60   4200    青荷里晨风园 2室1卫1厅 60平精装修 4200元/月   \n",
       "6   朝阳朝阳公园朝阳公园西里北区        61   6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居   \n",
       "7        西城广安门京铁和园        35   4600     白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住   \n",
       "8    丰台看丹桥造甲街南里5号院        60   6000         全新自住装修造甲街南里6000块钱南北通透两居   \n",
       "9       大兴亦庄君安国际公寓       147  11000  君安国际公寓 3室2卫2厅 147平精装修 12000元/月   \n",
       "11      朝阳朝青南太平庄北巷        20   2260        相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧   \n",
       "13      大兴亦庄君安国际公寓       107   7500        实景实价 君安和国际 两居两卫 空房出租 随时看   \n",
       "14        海淀公主坟国悦府        96  19000             国悦府 1室1厅1卫 带飘窗 经典实用   \n",
       "15        朝阳燕莎亮马名居       115  14000    朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全   \n",
       "17      朝阳朝阳公园枣营南里        58   7500       朝阳公园 麦子店枣营南里精装双南向 两居室 随时住   \n",
       "18        丰台洋桥海户西里        85   2860  三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍   \n",
       "19     丰台玉泉营万年花城一期        18   2330  首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租   \n",
       "20      房山房山城关福胜家园        87   2200    房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费   \n",
       "21      丰台赵公口彩虹城四区        52   4800            相寓 赵公口·彩虹城四区·低楼层·1居室   \n",
       "22  房山房山城关中国铁建原香漫谷        88   2800       整租 · 房山城关 · 原香漫谷三区 · 3室1厅   \n",
       "26      朝阳百子湾沿海赛洛城       103  10500      地铁7号线!急租三居室!南北通透!采光充足!随时看房   \n",
       "27        房山长阳长阳半岛        86   4600   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖   \n",
       "29       房山长阳首创新悦都        75   4300        整租 · 长阳 · 首创新悦都二区 · 2室1厅   \n",
       "30      怀柔怀柔城区美丽家园        91   2000          南北通透 美丽家园 2室1厅 2000元/月   \n",
       "31      海淀万柳光大水墨风景        97  18000  万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室   \n",
       "33     怀柔怀柔城区南华园四区        87   2400  南华园四区 2室1卫2厅 87.03平简装修 2400元/月   \n",
       "34     房山长阳首开熙悦山澜庭        90   5000   长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖   \n",
       "35        房山长阳长阳半岛        86   4700   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖   \n",
       "36      朝阳百子湾沿海赛洛城        69   6300       可!看房随时!东西一居室!价格可砍!高层!采光充足   \n",
       "37       丰台岳各庄万科紫台       173  14000               出租 万科紫台 3室 南北 精装修   \n",
       "38     房山长阳首开熙悦山澜庭        83   5200          整租 · 长阳 · 熙悦山南区 · 2室1厅   \n",
       "39      丰台青塔首创天阅山河       135  11000             出租 首创天阅山河 3室 南北 精装修   \n",
       "40      朝阳百子湾沿海赛洛城        97   8200                    国贸 双井 南北通透两居   \n",
       "42        海淀世纪城时雨园       167  17300       世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南   \n",
       "44      西城牛街牛街西里二区        55  14000      新出牛街西里二区 3室 精装修+有电梯+近地铁+超市   \n",
       "45     西城广安门荣丰2008        32   3800              出租 荣丰2008 1室 南 简装修   \n",
       "46     西城广安门荣丰2008        25   3900              出租 荣丰2008 1室 北 简装修   \n",
       "48     房山长阳首开熙悦山澜庭        74   4500          整租 · 长阳 · 熙悦山南区 · 2室1厅   \n",
       "51        丰台青塔福悦四季        40   4200  地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房   \n",
       "52      怀柔怀柔城区湖光小区        53   2300   湖光小区 2室1卫1厅 53.04平简装修 2300元/月   \n",
       "53   海淀世纪城世纪城三期翠叠园       127  15300  新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!   \n",
       "54     怀柔怀柔城区金台园小区        74   2400                南北通透金台园小区3室1厅精装修   \n",
       "55     房山长阳首开熙悦山澜庭        90   4800          整租 · 长阳 · 熙悦山南区 · 2室1厅   \n",
       "56     西城广安门玺源台·承玺        32   5800             出租 玺源台·承玺 1室 南向 简装修   \n",
       "57     西城广安门荣丰2008        24   4100              出租 荣丰2008 1室 北 简装修   \n",
       "58       西城广安门远见名苑        57   5500                出租 远见名苑 1室 西 简装修   \n",
       "59       怀柔雁栖世嘉光织谷        95   2300                     正南世嘉光织谷2室2厅   \n",
       "\n",
       "      perprice  \n",
       "2   157.272727  \n",
       "3   102.222222  \n",
       "4   141.304348  \n",
       "5    70.000000  \n",
       "6   106.557377  \n",
       "7   131.428571  \n",
       "8   100.000000  \n",
       "9    74.829932  \n",
       "11  113.000000  \n",
       "13   70.093458  \n",
       "14  197.916667  \n",
       "15  121.739130  \n",
       "17  129.310345  \n",
       "18   33.647059  \n",
       "19  129.444444  \n",
       "20   25.287356  \n",
       "21   92.307692  \n",
       "22   31.818182  \n",
       "26  101.941748  \n",
       "27   53.488372  \n",
       "29   57.333333  \n",
       "30   21.978022  \n",
       "31  185.567010  \n",
       "33   27.586207  \n",
       "34   55.555556  \n",
       "35   54.651163  \n",
       "36   91.304348  \n",
       "37   80.924855  \n",
       "38   62.650602  \n",
       "39   81.481481  \n",
       "40   84.536082  \n",
       "42  103.592814  \n",
       "44  254.545455  \n",
       "45  118.750000  \n",
       "46  156.000000  \n",
       "48   60.810811  \n",
       "51  105.000000  \n",
       "52   43.396226  \n",
       "53  120.472441  \n",
       "54   32.432432  \n",
       "55   53.333333  \n",
       "56  181.250000  \n",
       "57  170.833333  \n",
       "58   96.491228  \n",
       "59   24.210526  "
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>areaSize</th>\n",
       "      <th>price</th>\n",
       "      <th>title</th>\n",
       "      <th>perprice</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>海淀万柳锋尚国际公寓</td>\n",
       "      <td>110</td>\n",
       "      <td>17300</td>\n",
       "      <td>万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错</td>\n",
       "      <td>157.272727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>丰台岳各庄大成郡</td>\n",
       "      <td>135</td>\n",
       "      <td>13800</td>\n",
       "      <td>出租 大成郡 3室 南北 精装修</td>\n",
       "      <td>102.222222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>46</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "      <td>141.304348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>朝阳豆各庄青荷里晨风园</td>\n",
       "      <td>60</td>\n",
       "      <td>4200</td>\n",
       "      <td>青荷里晨风园 2室1卫1厅 60平精装修 4200元/月</td>\n",
       "      <td>70.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>61</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "      <td>106.557377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>西城广安门京铁和园</td>\n",
       "      <td>35</td>\n",
       "      <td>4600</td>\n",
       "      <td>白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住</td>\n",
       "      <td>131.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>丰台看丹桥造甲街南里5号院</td>\n",
       "      <td>60</td>\n",
       "      <td>6000</td>\n",
       "      <td>全新自住装修造甲街南里6000块钱南北通透两居</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>147</td>\n",
       "      <td>11000</td>\n",
       "      <td>君安国际公寓 3室2卫2厅 147平精装修 12000元/月</td>\n",
       "      <td>74.829932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>朝阳朝青南太平庄北巷</td>\n",
       "      <td>20</td>\n",
       "      <td>2260</td>\n",
       "      <td>相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧</td>\n",
       "      <td>113.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>107</td>\n",
       "      <td>7500</td>\n",
       "      <td>实景实价 君安和国际 两居两卫 空房出租 随时看</td>\n",
       "      <td>70.093458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>海淀公主坟国悦府</td>\n",
       "      <td>96</td>\n",
       "      <td>19000</td>\n",
       "      <td>国悦府 1室1厅1卫 带飘窗 经典实用</td>\n",
       "      <td>197.916667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>朝阳燕莎亮马名居</td>\n",
       "      <td>115</td>\n",
       "      <td>14000</td>\n",
       "      <td>朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全</td>\n",
       "      <td>121.739130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>朝阳朝阳公园枣营南里</td>\n",
       "      <td>58</td>\n",
       "      <td>7500</td>\n",
       "      <td>朝阳公园 麦子店枣营南里精装双南向 两居室 随时住</td>\n",
       "      <td>129.310345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>丰台洋桥海户西里</td>\n",
       "      <td>85</td>\n",
       "      <td>2860</td>\n",
       "      <td>三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍</td>\n",
       "      <td>33.647059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>丰台玉泉营万年花城一期</td>\n",
       "      <td>18</td>\n",
       "      <td>2330</td>\n",
       "      <td>首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租</td>\n",
       "      <td>129.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>房山房山城关福胜家园</td>\n",
       "      <td>87</td>\n",
       "      <td>2200</td>\n",
       "      <td>房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费</td>\n",
       "      <td>25.287356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>丰台赵公口彩虹城四区</td>\n",
       "      <td>52</td>\n",
       "      <td>4800</td>\n",
       "      <td>相寓 赵公口·彩虹城四区·低楼层·1居室</td>\n",
       "      <td>92.307692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>房山房山城关中国铁建原香漫谷</td>\n",
       "      <td>88</td>\n",
       "      <td>2800</td>\n",
       "      <td>整租 · 房山城关 · 原香漫谷三区 · 3室1厅</td>\n",
       "      <td>31.818182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>103</td>\n",
       "      <td>10500</td>\n",
       "      <td>地铁7号线!急租三居室!南北通透!采光充足!随时看房</td>\n",
       "      <td>101.941748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86</td>\n",
       "      <td>4600</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "      <td>53.488372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>房山长阳首创新悦都</td>\n",
       "      <td>75</td>\n",
       "      <td>4300</td>\n",
       "      <td>整租 · 长阳 · 首创新悦都二区 · 2室1厅</td>\n",
       "      <td>57.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>怀柔怀柔城区美丽家园</td>\n",
       "      <td>91</td>\n",
       "      <td>2000</td>\n",
       "      <td>南北通透 美丽家园 2室1厅 2000元/月</td>\n",
       "      <td>21.978022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>海淀万柳光大水墨风景</td>\n",
       "      <td>97</td>\n",
       "      <td>18000</td>\n",
       "      <td>万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室</td>\n",
       "      <td>185.567010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>怀柔怀柔城区南华园四区</td>\n",
       "      <td>87</td>\n",
       "      <td>2400</td>\n",
       "      <td>南华园四区 2室1卫2厅 87.03平简装修 2400元/月</td>\n",
       "      <td>27.586207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90</td>\n",
       "      <td>5000</td>\n",
       "      <td>长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖</td>\n",
       "      <td>55.555556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86</td>\n",
       "      <td>4700</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "      <td>54.651163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>69</td>\n",
       "      <td>6300</td>\n",
       "      <td>可!看房随时!东西一居室!价格可砍!高层!采光充足</td>\n",
       "      <td>91.304348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>丰台岳各庄万科紫台</td>\n",
       "      <td>173</td>\n",
       "      <td>14000</td>\n",
       "      <td>出租 万科紫台 3室 南北 精装修</td>\n",
       "      <td>80.924855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>83</td>\n",
       "      <td>5200</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "      <td>62.650602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>丰台青塔首创天阅山河</td>\n",
       "      <td>135</td>\n",
       "      <td>11000</td>\n",
       "      <td>出租 首创天阅山河 3室 南北 精装修</td>\n",
       "      <td>81.481481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>97</td>\n",
       "      <td>8200</td>\n",
       "      <td>国贸 双井 南北通透两居</td>\n",
       "      <td>84.536082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>海淀世纪城时雨园</td>\n",
       "      <td>167</td>\n",
       "      <td>17300</td>\n",
       "      <td>世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南</td>\n",
       "      <td>103.592814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>西城牛街牛街西里二区</td>\n",
       "      <td>55</td>\n",
       "      <td>14000</td>\n",
       "      <td>新出牛街西里二区 3室 精装修+有电梯+近地铁+超市</td>\n",
       "      <td>254.545455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>32</td>\n",
       "      <td>3800</td>\n",
       "      <td>出租 荣丰2008 1室 南 简装修</td>\n",
       "      <td>118.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>25</td>\n",
       "      <td>3900</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "      <td>156.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>74</td>\n",
       "      <td>4500</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "      <td>60.810811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>丰台青塔福悦四季</td>\n",
       "      <td>40</td>\n",
       "      <td>4200</td>\n",
       "      <td>地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房</td>\n",
       "      <td>105.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>怀柔怀柔城区湖光小区</td>\n",
       "      <td>53</td>\n",
       "      <td>2300</td>\n",
       "      <td>湖光小区 2室1卫1厅 53.04平简装修 2300元/月</td>\n",
       "      <td>43.396226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>海淀世纪城世纪城三期翠叠园</td>\n",
       "      <td>127</td>\n",
       "      <td>15300</td>\n",
       "      <td>新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!</td>\n",
       "      <td>120.472441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>怀柔怀柔城区金台园小区</td>\n",
       "      <td>74</td>\n",
       "      <td>2400</td>\n",
       "      <td>南北通透金台园小区3室1厅精装修</td>\n",
       "      <td>32.432432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90</td>\n",
       "      <td>4800</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "      <td>53.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>西城广安门玺源台·承玺</td>\n",
       "      <td>32</td>\n",
       "      <td>5800</td>\n",
       "      <td>出租 玺源台·承玺 1室 南向 简装修</td>\n",
       "      <td>181.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>24</td>\n",
       "      <td>4100</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "      <td>170.833333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>西城广安门远见名苑</td>\n",
       "      <td>57</td>\n",
       "      <td>5500</td>\n",
       "      <td>出租 远见名苑 1室 西 简装修</td>\n",
       "      <td>96.491228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>怀柔雁栖世嘉光织谷</td>\n",
       "      <td>95</td>\n",
       "      <td>2300</td>\n",
       "      <td>正南世嘉光织谷2室2厅</td>\n",
       "      <td>24.210526</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 56
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-20T08:46:29.764676Z",
     "start_time": "2024-05-20T08:46:29.745452Z"
    }
   },
   "cell_type": "code",
   "source": [
    "data.info()\n",
    "data"
   ],
   "id": "da47af021bd97892",
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 45 entries, 2 to 59\n",
      "Data columns (total 4 columns):\n",
      " #   Column    Non-Null Count  Dtype \n",
      "---  ------    --------------  ----- \n",
      " 0   address   45 non-null     object\n",
      " 1   areaSize  45 non-null     object\n",
      " 2   price     45 non-null     int64 \n",
      " 3   title     45 non-null     object\n",
      "dtypes: int64(1), object(3)\n",
      "memory usage: 1.8+ KB\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "           address areaSize  price                           title\n",
       "2       海淀万柳锋尚国际公寓     110㎡  17300  万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错\n",
       "3         丰台岳各庄大成郡     135㎡  13800                出租 大成郡 3室 南北 精装修\n",
       "4   朝阳朝阳公园朝阳公园西里北区      46㎡   6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居\n",
       "5      朝阳豆各庄青荷里晨风园      60㎡   4200    青荷里晨风园 2室1卫1厅 60平精装修 4200元/月\n",
       "6   朝阳朝阳公园朝阳公园西里北区      61㎡   6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居\n",
       "7        西城广安门京铁和园      35㎡   4600     白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住\n",
       "8    丰台看丹桥造甲街南里5号院      60㎡   6000         全新自住装修造甲街南里6000块钱南北通透两居\n",
       "9       大兴亦庄君安国际公寓     147㎡  11000  君安国际公寓 3室2卫2厅 147平精装修 12000元/月\n",
       "11      朝阳朝青南太平庄北巷      20㎡   2260        相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧\n",
       "13      大兴亦庄君安国际公寓     107㎡   7500        实景实价 君安和国际 两居两卫 空房出租 随时看\n",
       "14        海淀公主坟国悦府      96㎡  19000             国悦府 1室1厅1卫 带飘窗 经典实用\n",
       "15        朝阳燕莎亮马名居     115㎡  14000    朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全\n",
       "17      朝阳朝阳公园枣营南里      58㎡   7500       朝阳公园 麦子店枣营南里精装双南向 两居室 随时住\n",
       "18        丰台洋桥海户西里      85㎡   2860  三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍\n",
       "19     丰台玉泉营万年花城一期      18㎡   2330  首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租\n",
       "20      房山房山城关福胜家园      87㎡   2200    房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费\n",
       "21      丰台赵公口彩虹城四区      52㎡   4800            相寓 赵公口·彩虹城四区·低楼层·1居室\n",
       "22  房山房山城关中国铁建原香漫谷      88㎡   2800       整租 · 房山城关 · 原香漫谷三区 · 3室1厅\n",
       "26      朝阳百子湾沿海赛洛城     103㎡  10500      地铁7号线!急租三居室!南北通透!采光充足!随时看房\n",
       "27        房山长阳长阳半岛      86㎡   4600   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖\n",
       "29       房山长阳首创新悦都      75㎡   4300        整租 · 长阳 · 首创新悦都二区 · 2室1厅\n",
       "30      怀柔怀柔城区美丽家园      91㎡   2000          南北通透 美丽家园 2室1厅 2000元/月\n",
       "31      海淀万柳光大水墨风景      97㎡  18000  万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室\n",
       "33     怀柔怀柔城区南华园四区      87㎡   2400  南华园四区 2室1卫2厅 87.03平简装修 2400元/月\n",
       "34     房山长阳首开熙悦山澜庭      90㎡   5000   长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖\n",
       "35        房山长阳长阳半岛      86㎡   4700   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖\n",
       "36      朝阳百子湾沿海赛洛城      69㎡   6300       可!看房随时!东西一居室!价格可砍!高层!采光充足\n",
       "37       丰台岳各庄万科紫台     173㎡  14000               出租 万科紫台 3室 南北 精装修\n",
       "38     房山长阳首开熙悦山澜庭      83㎡   5200          整租 · 长阳 · 熙悦山南区 · 2室1厅\n",
       "39      丰台青塔首创天阅山河     135㎡  11000             出租 首创天阅山河 3室 南北 精装修\n",
       "40      朝阳百子湾沿海赛洛城      97㎡   8200                    国贸 双井 南北通透两居\n",
       "42        海淀世纪城时雨园     167㎡  17300       世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南\n",
       "44      西城牛街牛街西里二区      55㎡  14000      新出牛街西里二区 3室 精装修+有电梯+近地铁+超市\n",
       "45     西城广安门荣丰2008      32㎡   3800              出租 荣丰2008 1室 南 简装修\n",
       "46     西城广安门荣丰2008      25㎡   3900              出租 荣丰2008 1室 北 简装修\n",
       "48     房山长阳首开熙悦山澜庭      74㎡   4500          整租 · 长阳 · 熙悦山南区 · 2室1厅\n",
       "51        丰台青塔福悦四季      40㎡   4200  地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房\n",
       "52      怀柔怀柔城区湖光小区      53㎡   2300   湖光小区 2室1卫1厅 53.04平简装修 2300元/月\n",
       "53   海淀世纪城世纪城三期翠叠园     127㎡  15300  新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!\n",
       "54     怀柔怀柔城区金台园小区      74㎡   2400                南北通透金台园小区3室1厅精装修\n",
       "55     房山长阳首开熙悦山澜庭      90㎡   4800          整租 · 长阳 · 熙悦山南区 · 2室1厅\n",
       "56     西城广安门玺源台·承玺      32㎡   5800             出租 玺源台·承玺 1室 南向 简装修\n",
       "57     西城广安门荣丰2008      24㎡   4100              出租 荣丰2008 1室 北 简装修\n",
       "58       西城广安门远见名苑      57㎡   5500                出租 远见名苑 1室 西 简装修\n",
       "59       怀柔雁栖世嘉光织谷      95㎡   2300                     正南世嘉光织谷2室2厅"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>areaSize</th>\n",
       "      <th>price</th>\n",
       "      <th>title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>海淀万柳锋尚国际公寓</td>\n",
       "      <td>110㎡</td>\n",
       "      <td>17300</td>\n",
       "      <td>万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>丰台岳各庄大成郡</td>\n",
       "      <td>135㎡</td>\n",
       "      <td>13800</td>\n",
       "      <td>出租 大成郡 3室 南北 精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>46㎡</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>朝阳豆各庄青荷里晨风园</td>\n",
       "      <td>60㎡</td>\n",
       "      <td>4200</td>\n",
       "      <td>青荷里晨风园 2室1卫1厅 60平精装修 4200元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>61㎡</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>西城广安门京铁和园</td>\n",
       "      <td>35㎡</td>\n",
       "      <td>4600</td>\n",
       "      <td>白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>丰台看丹桥造甲街南里5号院</td>\n",
       "      <td>60㎡</td>\n",
       "      <td>6000</td>\n",
       "      <td>全新自住装修造甲街南里6000块钱南北通透两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>147㎡</td>\n",
       "      <td>11000</td>\n",
       "      <td>君安国际公寓 3室2卫2厅 147平精装修 12000元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>朝阳朝青南太平庄北巷</td>\n",
       "      <td>20㎡</td>\n",
       "      <td>2260</td>\n",
       "      <td>相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>107㎡</td>\n",
       "      <td>7500</td>\n",
       "      <td>实景实价 君安和国际 两居两卫 空房出租 随时看</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>海淀公主坟国悦府</td>\n",
       "      <td>96㎡</td>\n",
       "      <td>19000</td>\n",
       "      <td>国悦府 1室1厅1卫 带飘窗 经典实用</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>朝阳燕莎亮马名居</td>\n",
       "      <td>115㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>朝阳朝阳公园枣营南里</td>\n",
       "      <td>58㎡</td>\n",
       "      <td>7500</td>\n",
       "      <td>朝阳公园 麦子店枣营南里精装双南向 两居室 随时住</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>丰台洋桥海户西里</td>\n",
       "      <td>85㎡</td>\n",
       "      <td>2860</td>\n",
       "      <td>三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>丰台玉泉营万年花城一期</td>\n",
       "      <td>18㎡</td>\n",
       "      <td>2330</td>\n",
       "      <td>首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>房山房山城关福胜家园</td>\n",
       "      <td>87㎡</td>\n",
       "      <td>2200</td>\n",
       "      <td>房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>丰台赵公口彩虹城四区</td>\n",
       "      <td>52㎡</td>\n",
       "      <td>4800</td>\n",
       "      <td>相寓 赵公口·彩虹城四区·低楼层·1居室</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>房山房山城关中国铁建原香漫谷</td>\n",
       "      <td>88㎡</td>\n",
       "      <td>2800</td>\n",
       "      <td>整租 · 房山城关 · 原香漫谷三区 · 3室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>103㎡</td>\n",
       "      <td>10500</td>\n",
       "      <td>地铁7号线!急租三居室!南北通透!采光充足!随时看房</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86㎡</td>\n",
       "      <td>4600</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>房山长阳首创新悦都</td>\n",
       "      <td>75㎡</td>\n",
       "      <td>4300</td>\n",
       "      <td>整租 · 长阳 · 首创新悦都二区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>怀柔怀柔城区美丽家园</td>\n",
       "      <td>91㎡</td>\n",
       "      <td>2000</td>\n",
       "      <td>南北通透 美丽家园 2室1厅 2000元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>海淀万柳光大水墨风景</td>\n",
       "      <td>97㎡</td>\n",
       "      <td>18000</td>\n",
       "      <td>万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>怀柔怀柔城区南华园四区</td>\n",
       "      <td>87㎡</td>\n",
       "      <td>2400</td>\n",
       "      <td>南华园四区 2室1卫2厅 87.03平简装修 2400元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90㎡</td>\n",
       "      <td>5000</td>\n",
       "      <td>长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86㎡</td>\n",
       "      <td>4700</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>69㎡</td>\n",
       "      <td>6300</td>\n",
       "      <td>可!看房随时!东西一居室!价格可砍!高层!采光充足</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>丰台岳各庄万科紫台</td>\n",
       "      <td>173㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>出租 万科紫台 3室 南北 精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>83㎡</td>\n",
       "      <td>5200</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>丰台青塔首创天阅山河</td>\n",
       "      <td>135㎡</td>\n",
       "      <td>11000</td>\n",
       "      <td>出租 首创天阅山河 3室 南北 精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>97㎡</td>\n",
       "      <td>8200</td>\n",
       "      <td>国贸 双井 南北通透两居</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>海淀世纪城时雨园</td>\n",
       "      <td>167㎡</td>\n",
       "      <td>17300</td>\n",
       "      <td>世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>西城牛街牛街西里二区</td>\n",
       "      <td>55㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>新出牛街西里二区 3室 精装修+有电梯+近地铁+超市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>32㎡</td>\n",
       "      <td>3800</td>\n",
       "      <td>出租 荣丰2008 1室 南 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>25㎡</td>\n",
       "      <td>3900</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>74㎡</td>\n",
       "      <td>4500</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>丰台青塔福悦四季</td>\n",
       "      <td>40㎡</td>\n",
       "      <td>4200</td>\n",
       "      <td>地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>怀柔怀柔城区湖光小区</td>\n",
       "      <td>53㎡</td>\n",
       "      <td>2300</td>\n",
       "      <td>湖光小区 2室1卫1厅 53.04平简装修 2300元/月</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>海淀世纪城世纪城三期翠叠园</td>\n",
       "      <td>127㎡</td>\n",
       "      <td>15300</td>\n",
       "      <td>新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>怀柔怀柔城区金台园小区</td>\n",
       "      <td>74㎡</td>\n",
       "      <td>2400</td>\n",
       "      <td>南北通透金台园小区3室1厅精装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90㎡</td>\n",
       "      <td>4800</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>西城广安门玺源台·承玺</td>\n",
       "      <td>32㎡</td>\n",
       "      <td>5800</td>\n",
       "      <td>出租 玺源台·承玺 1室 南向 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>24㎡</td>\n",
       "      <td>4100</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>西城广安门远见名苑</td>\n",
       "      <td>57㎡</td>\n",
       "      <td>5500</td>\n",
       "      <td>出租 远见名苑 1室 西 简装修</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>怀柔雁栖世嘉光织谷</td>\n",
       "      <td>95㎡</td>\n",
       "      <td>2300</td>\n",
       "      <td>正南世嘉光织谷2室2厅</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 58
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-20T08:50:50.038520Z",
     "start_time": "2024-05-20T08:50:50.006944Z"
    }
   },
   "cell_type": "code",
   "source": [
    "data2 = data.copy()\n",
    "data2[\"perprice\"] = data1[\"perprice\"].apply(lambda x : float(\"%.2f\" % x))\n",
    "data2"
   ],
   "id": "367c79f98f4c80a5",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "           address areaSize  price                           title  perprice\n",
       "2       海淀万柳锋尚国际公寓     110㎡  17300  万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错    157.27\n",
       "3         丰台岳各庄大成郡     135㎡  13800                出租 大成郡 3室 南北 精装修    102.22\n",
       "4   朝阳朝阳公园朝阳公园西里北区      46㎡   6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居    141.30\n",
       "5      朝阳豆各庄青荷里晨风园      60㎡   4200    青荷里晨风园 2室1卫1厅 60平精装修 4200元/月     70.00\n",
       "6   朝阳朝阳公园朝阳公园西里北区      61㎡   6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居    106.56\n",
       "7        西城广安门京铁和园      35㎡   4600     白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住    131.43\n",
       "8    丰台看丹桥造甲街南里5号院      60㎡   6000         全新自住装修造甲街南里6000块钱南北通透两居    100.00\n",
       "9       大兴亦庄君安国际公寓     147㎡  11000  君安国际公寓 3室2卫2厅 147平精装修 12000元/月     74.83\n",
       "11      朝阳朝青南太平庄北巷      20㎡   2260        相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧    113.00\n",
       "13      大兴亦庄君安国际公寓     107㎡   7500        实景实价 君安和国际 两居两卫 空房出租 随时看     70.09\n",
       "14        海淀公主坟国悦府      96㎡  19000             国悦府 1室1厅1卫 带飘窗 经典实用    197.92\n",
       "15        朝阳燕莎亮马名居     115㎡  14000    朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全    121.74\n",
       "17      朝阳朝阳公园枣营南里      58㎡   7500       朝阳公园 麦子店枣营南里精装双南向 两居室 随时住    129.31\n",
       "18        丰台洋桥海户西里      85㎡   2860  三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍     33.65\n",
       "19     丰台玉泉营万年花城一期      18㎡   2330  首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租    129.44\n",
       "20      房山房山城关福胜家园      87㎡   2200    房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费     25.29\n",
       "21      丰台赵公口彩虹城四区      52㎡   4800            相寓 赵公口·彩虹城四区·低楼层·1居室     92.31\n",
       "22  房山房山城关中国铁建原香漫谷      88㎡   2800       整租 · 房山城关 · 原香漫谷三区 · 3室1厅     31.82\n",
       "26      朝阳百子湾沿海赛洛城     103㎡  10500      地铁7号线!急租三居室!南北通透!采光充足!随时看房    101.94\n",
       "27        房山长阳长阳半岛      86㎡   4600   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖     53.49\n",
       "29       房山长阳首创新悦都      75㎡   4300        整租 · 长阳 · 首创新悦都二区 · 2室1厅     57.33\n",
       "30      怀柔怀柔城区美丽家园      91㎡   2000          南北通透 美丽家园 2室1厅 2000元/月     21.98\n",
       "31      海淀万柳光大水墨风景      97㎡  18000  万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室    185.57\n",
       "33     怀柔怀柔城区南华园四区      87㎡   2400  南华园四区 2室1卫2厅 87.03平简装修 2400元/月     27.59\n",
       "34     房山长阳首开熙悦山澜庭      90㎡   5000   长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖     55.56\n",
       "35        房山长阳长阳半岛      86㎡   4700   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖     54.65\n",
       "36      朝阳百子湾沿海赛洛城      69㎡   6300       可!看房随时!东西一居室!价格可砍!高层!采光充足     91.30\n",
       "37       丰台岳各庄万科紫台     173㎡  14000               出租 万科紫台 3室 南北 精装修     80.92\n",
       "38     房山长阳首开熙悦山澜庭      83㎡   5200          整租 · 长阳 · 熙悦山南区 · 2室1厅     62.65\n",
       "39      丰台青塔首创天阅山河     135㎡  11000             出租 首创天阅山河 3室 南北 精装修     81.48\n",
       "40      朝阳百子湾沿海赛洛城      97㎡   8200                    国贸 双井 南北通透两居     84.54\n",
       "42        海淀世纪城时雨园     167㎡  17300       世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南    103.59\n",
       "44      西城牛街牛街西里二区      55㎡  14000      新出牛街西里二区 3室 精装修+有电梯+近地铁+超市    254.55\n",
       "45     西城广安门荣丰2008      32㎡   3800              出租 荣丰2008 1室 南 简装修    118.75\n",
       "46     西城广安门荣丰2008      25㎡   3900              出租 荣丰2008 1室 北 简装修    156.00\n",
       "48     房山长阳首开熙悦山澜庭      74㎡   4500          整租 · 长阳 · 熙悦山南区 · 2室1厅     60.81\n",
       "51        丰台青塔福悦四季      40㎡   4200  地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房    105.00\n",
       "52      怀柔怀柔城区湖光小区      53㎡   2300   湖光小区 2室1卫1厅 53.04平简装修 2300元/月     43.40\n",
       "53   海淀世纪城世纪城三期翠叠园     127㎡  15300  新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!    120.47\n",
       "54     怀柔怀柔城区金台园小区      74㎡   2400                南北通透金台园小区3室1厅精装修     32.43\n",
       "55     房山长阳首开熙悦山澜庭      90㎡   4800          整租 · 长阳 · 熙悦山南区 · 2室1厅     53.33\n",
       "56     西城广安门玺源台·承玺      32㎡   5800             出租 玺源台·承玺 1室 南向 简装修    181.25\n",
       "57     西城广安门荣丰2008      24㎡   4100              出租 荣丰2008 1室 北 简装修    170.83\n",
       "58       西城广安门远见名苑      57㎡   5500                出租 远见名苑 1室 西 简装修     96.49\n",
       "59       怀柔雁栖世嘉光织谷      95㎡   2300                     正南世嘉光织谷2室2厅     24.21"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>areaSize</th>\n",
       "      <th>price</th>\n",
       "      <th>title</th>\n",
       "      <th>perprice</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>海淀万柳锋尚国际公寓</td>\n",
       "      <td>110㎡</td>\n",
       "      <td>17300</td>\n",
       "      <td>万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错</td>\n",
       "      <td>157.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>丰台岳各庄大成郡</td>\n",
       "      <td>135㎡</td>\n",
       "      <td>13800</td>\n",
       "      <td>出租 大成郡 3室 南北 精装修</td>\n",
       "      <td>102.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>46㎡</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "      <td>141.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>朝阳豆各庄青荷里晨风园</td>\n",
       "      <td>60㎡</td>\n",
       "      <td>4200</td>\n",
       "      <td>青荷里晨风园 2室1卫1厅 60平精装修 4200元/月</td>\n",
       "      <td>70.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>61㎡</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "      <td>106.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>西城广安门京铁和园</td>\n",
       "      <td>35㎡</td>\n",
       "      <td>4600</td>\n",
       "      <td>白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住</td>\n",
       "      <td>131.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>丰台看丹桥造甲街南里5号院</td>\n",
       "      <td>60㎡</td>\n",
       "      <td>6000</td>\n",
       "      <td>全新自住装修造甲街南里6000块钱南北通透两居</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>147㎡</td>\n",
       "      <td>11000</td>\n",
       "      <td>君安国际公寓 3室2卫2厅 147平精装修 12000元/月</td>\n",
       "      <td>74.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>朝阳朝青南太平庄北巷</td>\n",
       "      <td>20㎡</td>\n",
       "      <td>2260</td>\n",
       "      <td>相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧</td>\n",
       "      <td>113.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>107㎡</td>\n",
       "      <td>7500</td>\n",
       "      <td>实景实价 君安和国际 两居两卫 空房出租 随时看</td>\n",
       "      <td>70.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>海淀公主坟国悦府</td>\n",
       "      <td>96㎡</td>\n",
       "      <td>19000</td>\n",
       "      <td>国悦府 1室1厅1卫 带飘窗 经典实用</td>\n",
       "      <td>197.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>朝阳燕莎亮马名居</td>\n",
       "      <td>115㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全</td>\n",
       "      <td>121.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>朝阳朝阳公园枣营南里</td>\n",
       "      <td>58㎡</td>\n",
       "      <td>7500</td>\n",
       "      <td>朝阳公园 麦子店枣营南里精装双南向 两居室 随时住</td>\n",
       "      <td>129.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>丰台洋桥海户西里</td>\n",
       "      <td>85㎡</td>\n",
       "      <td>2860</td>\n",
       "      <td>三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍</td>\n",
       "      <td>33.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>丰台玉泉营万年花城一期</td>\n",
       "      <td>18㎡</td>\n",
       "      <td>2330</td>\n",
       "      <td>首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租</td>\n",
       "      <td>129.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>房山房山城关福胜家园</td>\n",
       "      <td>87㎡</td>\n",
       "      <td>2200</td>\n",
       "      <td>房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费</td>\n",
       "      <td>25.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>丰台赵公口彩虹城四区</td>\n",
       "      <td>52㎡</td>\n",
       "      <td>4800</td>\n",
       "      <td>相寓 赵公口·彩虹城四区·低楼层·1居室</td>\n",
       "      <td>92.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>房山房山城关中国铁建原香漫谷</td>\n",
       "      <td>88㎡</td>\n",
       "      <td>2800</td>\n",
       "      <td>整租 · 房山城关 · 原香漫谷三区 · 3室1厅</td>\n",
       "      <td>31.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>103㎡</td>\n",
       "      <td>10500</td>\n",
       "      <td>地铁7号线!急租三居室!南北通透!采光充足!随时看房</td>\n",
       "      <td>101.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86㎡</td>\n",
       "      <td>4600</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "      <td>53.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>房山长阳首创新悦都</td>\n",
       "      <td>75㎡</td>\n",
       "      <td>4300</td>\n",
       "      <td>整租 · 长阳 · 首创新悦都二区 · 2室1厅</td>\n",
       "      <td>57.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>怀柔怀柔城区美丽家园</td>\n",
       "      <td>91㎡</td>\n",
       "      <td>2000</td>\n",
       "      <td>南北通透 美丽家园 2室1厅 2000元/月</td>\n",
       "      <td>21.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>海淀万柳光大水墨风景</td>\n",
       "      <td>97㎡</td>\n",
       "      <td>18000</td>\n",
       "      <td>万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室</td>\n",
       "      <td>185.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>怀柔怀柔城区南华园四区</td>\n",
       "      <td>87㎡</td>\n",
       "      <td>2400</td>\n",
       "      <td>南华园四区 2室1卫2厅 87.03平简装修 2400元/月</td>\n",
       "      <td>27.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90㎡</td>\n",
       "      <td>5000</td>\n",
       "      <td>长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖</td>\n",
       "      <td>55.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86㎡</td>\n",
       "      <td>4700</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "      <td>54.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>69㎡</td>\n",
       "      <td>6300</td>\n",
       "      <td>可!看房随时!东西一居室!价格可砍!高层!采光充足</td>\n",
       "      <td>91.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>丰台岳各庄万科紫台</td>\n",
       "      <td>173㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>出租 万科紫台 3室 南北 精装修</td>\n",
       "      <td>80.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>83㎡</td>\n",
       "      <td>5200</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "      <td>62.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>丰台青塔首创天阅山河</td>\n",
       "      <td>135㎡</td>\n",
       "      <td>11000</td>\n",
       "      <td>出租 首创天阅山河 3室 南北 精装修</td>\n",
       "      <td>81.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>97㎡</td>\n",
       "      <td>8200</td>\n",
       "      <td>国贸 双井 南北通透两居</td>\n",
       "      <td>84.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>海淀世纪城时雨园</td>\n",
       "      <td>167㎡</td>\n",
       "      <td>17300</td>\n",
       "      <td>世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南</td>\n",
       "      <td>103.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>西城牛街牛街西里二区</td>\n",
       "      <td>55㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>新出牛街西里二区 3室 精装修+有电梯+近地铁+超市</td>\n",
       "      <td>254.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>32㎡</td>\n",
       "      <td>3800</td>\n",
       "      <td>出租 荣丰2008 1室 南 简装修</td>\n",
       "      <td>118.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>25㎡</td>\n",
       "      <td>3900</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "      <td>156.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>74㎡</td>\n",
       "      <td>4500</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "      <td>60.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>丰台青塔福悦四季</td>\n",
       "      <td>40㎡</td>\n",
       "      <td>4200</td>\n",
       "      <td>地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房</td>\n",
       "      <td>105.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>怀柔怀柔城区湖光小区</td>\n",
       "      <td>53㎡</td>\n",
       "      <td>2300</td>\n",
       "      <td>湖光小区 2室1卫1厅 53.04平简装修 2300元/月</td>\n",
       "      <td>43.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>海淀世纪城世纪城三期翠叠园</td>\n",
       "      <td>127㎡</td>\n",
       "      <td>15300</td>\n",
       "      <td>新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!</td>\n",
       "      <td>120.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>怀柔怀柔城区金台园小区</td>\n",
       "      <td>74㎡</td>\n",
       "      <td>2400</td>\n",
       "      <td>南北通透金台园小区3室1厅精装修</td>\n",
       "      <td>32.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90㎡</td>\n",
       "      <td>4800</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "      <td>53.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>西城广安门玺源台·承玺</td>\n",
       "      <td>32㎡</td>\n",
       "      <td>5800</td>\n",
       "      <td>出租 玺源台·承玺 1室 南向 简装修</td>\n",
       "      <td>181.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>24㎡</td>\n",
       "      <td>4100</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "      <td>170.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>西城广安门远见名苑</td>\n",
       "      <td>57㎡</td>\n",
       "      <td>5500</td>\n",
       "      <td>出租 远见名苑 1室 西 简装修</td>\n",
       "      <td>96.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>怀柔雁栖世嘉光织谷</td>\n",
       "      <td>95㎡</td>\n",
       "      <td>2300</td>\n",
       "      <td>正南世嘉光织谷2室2厅</td>\n",
       "      <td>24.21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 67
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-05-20T08:51:03.547740Z",
     "start_time": "2024-05-20T08:51:03.516612Z"
    }
   },
   "cell_type": "code",
   "source": "data2.sort_values(by=\"perprice\")",
   "id": "854c1b3f02753352",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "           address areaSize  price                           title  perprice\n",
       "30      怀柔怀柔城区美丽家园      91㎡   2000          南北通透 美丽家园 2室1厅 2000元/月     21.98\n",
       "59       怀柔雁栖世嘉光织谷      95㎡   2300                     正南世嘉光织谷2室2厅     24.21\n",
       "20      房山房山城关福胜家园      87㎡   2200    房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费     25.29\n",
       "33     怀柔怀柔城区南华园四区      87㎡   2400  南华园四区 2室1卫2厅 87.03平简装修 2400元/月     27.59\n",
       "22  房山房山城关中国铁建原香漫谷      88㎡   2800       整租 · 房山城关 · 原香漫谷三区 · 3室1厅     31.82\n",
       "54     怀柔怀柔城区金台园小区      74㎡   2400                南北通透金台园小区3室1厅精装修     32.43\n",
       "18        丰台洋桥海户西里      85㎡   2860  三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍     33.65\n",
       "52      怀柔怀柔城区湖光小区      53㎡   2300   湖光小区 2室1卫1厅 53.04平简装修 2300元/月     43.40\n",
       "55     房山长阳首开熙悦山澜庭      90㎡   4800          整租 · 长阳 · 熙悦山南区 · 2室1厅     53.33\n",
       "27        房山长阳长阳半岛      86㎡   4600   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖     53.49\n",
       "35        房山长阳长阳半岛      86㎡   4700   长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖     54.65\n",
       "34     房山长阳首开熙悦山澜庭      90㎡   5000   长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖     55.56\n",
       "29       房山长阳首创新悦都      75㎡   4300        整租 · 长阳 · 首创新悦都二区 · 2室1厅     57.33\n",
       "48     房山长阳首开熙悦山澜庭      74㎡   4500          整租 · 长阳 · 熙悦山南区 · 2室1厅     60.81\n",
       "38     房山长阳首开熙悦山澜庭      83㎡   5200          整租 · 长阳 · 熙悦山南区 · 2室1厅     62.65\n",
       "5      朝阳豆各庄青荷里晨风园      60㎡   4200    青荷里晨风园 2室1卫1厅 60平精装修 4200元/月     70.00\n",
       "13      大兴亦庄君安国际公寓     107㎡   7500        实景实价 君安和国际 两居两卫 空房出租 随时看     70.09\n",
       "9       大兴亦庄君安国际公寓     147㎡  11000  君安国际公寓 3室2卫2厅 147平精装修 12000元/月     74.83\n",
       "37       丰台岳各庄万科紫台     173㎡  14000               出租 万科紫台 3室 南北 精装修     80.92\n",
       "39      丰台青塔首创天阅山河     135㎡  11000             出租 首创天阅山河 3室 南北 精装修     81.48\n",
       "40      朝阳百子湾沿海赛洛城      97㎡   8200                    国贸 双井 南北通透两居     84.54\n",
       "36      朝阳百子湾沿海赛洛城      69㎡   6300       可!看房随时!东西一居室!价格可砍!高层!采光充足     91.30\n",
       "21      丰台赵公口彩虹城四区      52㎡   4800            相寓 赵公口·彩虹城四区·低楼层·1居室     92.31\n",
       "58       西城广安门远见名苑      57㎡   5500                出租 远见名苑 1室 西 简装修     96.49\n",
       "8    丰台看丹桥造甲街南里5号院      60㎡   6000         全新自住装修造甲街南里6000块钱南北通透两居    100.00\n",
       "26      朝阳百子湾沿海赛洛城     103㎡  10500      地铁7号线!急租三居室!南北通透!采光充足!随时看房    101.94\n",
       "3         丰台岳各庄大成郡     135㎡  13800                出租 大成郡 3室 南北 精装修    102.22\n",
       "42        海淀世纪城时雨园     167㎡  17300       世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南    103.59\n",
       "51        丰台青塔福悦四季      40㎡   4200  地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房    105.00\n",
       "6   朝阳朝阳公园朝阳公园西里北区      61㎡   6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居    106.56\n",
       "11      朝阳朝青南太平庄北巷      20㎡   2260        相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧    113.00\n",
       "45     西城广安门荣丰2008      32㎡   3800              出租 荣丰2008 1室 南 简装修    118.75\n",
       "53   海淀世纪城世纪城三期翠叠园     127㎡  15300  新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!    120.47\n",
       "15        朝阳燕莎亮马名居     115㎡  14000    朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全    121.74\n",
       "17      朝阳朝阳公园枣营南里      58㎡   7500       朝阳公园 麦子店枣营南里精装双南向 两居室 随时住    129.31\n",
       "19     丰台玉泉营万年花城一期      18㎡   2330  首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租    129.44\n",
       "7        西城广安门京铁和园      35㎡   4600     白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住    131.43\n",
       "4   朝阳朝阳公园朝阳公园西里北区      46㎡   6500    麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居    141.30\n",
       "46     西城广安门荣丰2008      25㎡   3900              出租 荣丰2008 1室 北 简装修    156.00\n",
       "2       海淀万柳锋尚国际公寓     110㎡  17300  万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错    157.27\n",
       "57     西城广安门荣丰2008      24㎡   4100              出租 荣丰2008 1室 北 简装修    170.83\n",
       "56     西城广安门玺源台·承玺      32㎡   5800             出租 玺源台·承玺 1室 南向 简装修    181.25\n",
       "31      海淀万柳光大水墨风景      97㎡  18000  万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室    185.57\n",
       "14        海淀公主坟国悦府      96㎡  19000             国悦府 1室1厅1卫 带飘窗 经典实用    197.92\n",
       "44      西城牛街牛街西里二区      55㎡  14000      新出牛街西里二区 3室 精装修+有电梯+近地铁+超市    254.55"
      ],
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>areaSize</th>\n",
       "      <th>price</th>\n",
       "      <th>title</th>\n",
       "      <th>perprice</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>怀柔怀柔城区美丽家园</td>\n",
       "      <td>91㎡</td>\n",
       "      <td>2000</td>\n",
       "      <td>南北通透 美丽家园 2室1厅 2000元/月</td>\n",
       "      <td>21.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>怀柔雁栖世嘉光织谷</td>\n",
       "      <td>95㎡</td>\n",
       "      <td>2300</td>\n",
       "      <td>正南世嘉光织谷2室2厅</td>\n",
       "      <td>24.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>房山房山城关福胜家园</td>\n",
       "      <td>87㎡</td>\n",
       "      <td>2200</td>\n",
       "      <td>房山城关福胜家园2室1厅干净,通透,业主包物业费,取暖费</td>\n",
       "      <td>25.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>怀柔怀柔城区南华园四区</td>\n",
       "      <td>87㎡</td>\n",
       "      <td>2400</td>\n",
       "      <td>南华园四区 2室1卫2厅 87.03平简装修 2400元/月</td>\n",
       "      <td>27.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>房山房山城关中国铁建原香漫谷</td>\n",
       "      <td>88㎡</td>\n",
       "      <td>2800</td>\n",
       "      <td>整租 · 房山城关 · 原香漫谷三区 · 3室1厅</td>\n",
       "      <td>31.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>怀柔怀柔城区金台园小区</td>\n",
       "      <td>74㎡</td>\n",
       "      <td>2400</td>\n",
       "      <td>南北通透金台园小区3室1厅精装修</td>\n",
       "      <td>32.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>丰台洋桥海户西里</td>\n",
       "      <td>85㎡</td>\n",
       "      <td>2860</td>\n",
       "      <td>三环边洋桥附近 海户西里小区 押一付一 朝南大主卧阳台 实拍</td>\n",
       "      <td>33.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>怀柔怀柔城区湖光小区</td>\n",
       "      <td>53㎡</td>\n",
       "      <td>2300</td>\n",
       "      <td>湖光小区 2室1卫1厅 53.04平简装修 2300元/月</td>\n",
       "      <td>43.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90㎡</td>\n",
       "      <td>4800</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "      <td>53.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86㎡</td>\n",
       "      <td>4600</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "      <td>53.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>房山长阳长阳半岛</td>\n",
       "      <td>86㎡</td>\n",
       "      <td>4700</td>\n",
       "      <td>长阳地铁站旁 云湾家园 2室1厅 带电梯 民水民电集中供暖</td>\n",
       "      <td>54.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>90㎡</td>\n",
       "      <td>5000</td>\n",
       "      <td>长阳地铁站旁 熙悦山南区2室1厅 带电梯 民水民电集中供暖</td>\n",
       "      <td>55.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>房山长阳首创新悦都</td>\n",
       "      <td>75㎡</td>\n",
       "      <td>4300</td>\n",
       "      <td>整租 · 长阳 · 首创新悦都二区 · 2室1厅</td>\n",
       "      <td>57.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>74㎡</td>\n",
       "      <td>4500</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "      <td>60.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>房山长阳首开熙悦山澜庭</td>\n",
       "      <td>83㎡</td>\n",
       "      <td>5200</td>\n",
       "      <td>整租 · 长阳 · 熙悦山南区 · 2室1厅</td>\n",
       "      <td>62.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>朝阳豆各庄青荷里晨风园</td>\n",
       "      <td>60㎡</td>\n",
       "      <td>4200</td>\n",
       "      <td>青荷里晨风园 2室1卫1厅 60平精装修 4200元/月</td>\n",
       "      <td>70.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>107㎡</td>\n",
       "      <td>7500</td>\n",
       "      <td>实景实价 君安和国际 两居两卫 空房出租 随时看</td>\n",
       "      <td>70.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>大兴亦庄君安国际公寓</td>\n",
       "      <td>147㎡</td>\n",
       "      <td>11000</td>\n",
       "      <td>君安国际公寓 3室2卫2厅 147平精装修 12000元/月</td>\n",
       "      <td>74.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>丰台岳各庄万科紫台</td>\n",
       "      <td>173㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>出租 万科紫台 3室 南北 精装修</td>\n",
       "      <td>80.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>丰台青塔首创天阅山河</td>\n",
       "      <td>135㎡</td>\n",
       "      <td>11000</td>\n",
       "      <td>出租 首创天阅山河 3室 南北 精装修</td>\n",
       "      <td>81.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>97㎡</td>\n",
       "      <td>8200</td>\n",
       "      <td>国贸 双井 南北通透两居</td>\n",
       "      <td>84.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>69㎡</td>\n",
       "      <td>6300</td>\n",
       "      <td>可!看房随时!东西一居室!价格可砍!高层!采光充足</td>\n",
       "      <td>91.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>丰台赵公口彩虹城四区</td>\n",
       "      <td>52㎡</td>\n",
       "      <td>4800</td>\n",
       "      <td>相寓 赵公口·彩虹城四区·低楼层·1居室</td>\n",
       "      <td>92.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>西城广安门远见名苑</td>\n",
       "      <td>57㎡</td>\n",
       "      <td>5500</td>\n",
       "      <td>出租 远见名苑 1室 西 简装修</td>\n",
       "      <td>96.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>丰台看丹桥造甲街南里5号院</td>\n",
       "      <td>60㎡</td>\n",
       "      <td>6000</td>\n",
       "      <td>全新自住装修造甲街南里6000块钱南北通透两居</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>朝阳百子湾沿海赛洛城</td>\n",
       "      <td>103㎡</td>\n",
       "      <td>10500</td>\n",
       "      <td>地铁7号线!急租三居室!南北通透!采光充足!随时看房</td>\n",
       "      <td>101.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>丰台岳各庄大成郡</td>\n",
       "      <td>135㎡</td>\n",
       "      <td>13800</td>\n",
       "      <td>出租 大成郡 3室 南北 精装修</td>\n",
       "      <td>102.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>海淀世纪城时雨园</td>\n",
       "      <td>167㎡</td>\n",
       "      <td>17300</td>\n",
       "      <td>世纪城三期时雨园 4室2厅2卫 经典实用 主卧朝南</td>\n",
       "      <td>103.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>丰台青塔福悦四季</td>\n",
       "      <td>40㎡</td>\n",
       "      <td>4200</td>\n",
       "      <td>地铁14号线旁 福悦四季 整租 1室 朝南 家具可配随时看房</td>\n",
       "      <td>105.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>61㎡</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "      <td>106.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>朝阳朝青南太平庄北巷</td>\n",
       "      <td>20㎡</td>\n",
       "      <td>2260</td>\n",
       "      <td>相寓 高碑店·南太平庄北巷·高楼层·3居室·主卧</td>\n",
       "      <td>113.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>32㎡</td>\n",
       "      <td>3800</td>\n",
       "      <td>出租 荣丰2008 1室 南 简装修</td>\n",
       "      <td>118.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>海淀世纪城世纪城三期翠叠园</td>\n",
       "      <td>127㎡</td>\n",
       "      <td>15300</td>\n",
       "      <td>新出!世纪城翠叠园 大两居2室 近金源 近地铁 看房方便!!</td>\n",
       "      <td>120.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>朝阳燕莎亮马名居</td>\n",
       "      <td>115㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>朝阳公园蓝色港湾亮马名居 2室2厅2卫 精装修 配套齐全</td>\n",
       "      <td>121.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>朝阳朝阳公园枣营南里</td>\n",
       "      <td>58㎡</td>\n",
       "      <td>7500</td>\n",
       "      <td>朝阳公园 麦子店枣营南里精装双南向 两居室 随时住</td>\n",
       "      <td>129.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>丰台玉泉营万年花城一期</td>\n",
       "      <td>18㎡</td>\n",
       "      <td>2330</td>\n",
       "      <td>首经贸地铁站,押一付一,下楼就是地铁站,实拍精装次卧三户合租</td>\n",
       "      <td>129.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>西城广安门京铁和园</td>\n",
       "      <td>35㎡</td>\n",
       "      <td>4600</td>\n",
       "      <td>白纸坊 广安门 马连道 京铁和园 精装小公寓 随时入住</td>\n",
       "      <td>131.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>朝阳朝阳公园朝阳公园西里北区</td>\n",
       "      <td>46㎡</td>\n",
       "      <td>6500</td>\n",
       "      <td>麦子店 枣营北里 团结湖 农业展览馆 朝阳公园西里 两居</td>\n",
       "      <td>141.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>25㎡</td>\n",
       "      <td>3900</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "      <td>156.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>海淀万柳锋尚国际公寓</td>\n",
       "      <td>110㎡</td>\n",
       "      <td>17300</td>\n",
       "      <td>万柳商圈 锋尚国际公寓 西向品质两居室 小区环境好 装修不错</td>\n",
       "      <td>157.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>西城广安门荣丰2008</td>\n",
       "      <td>24㎡</td>\n",
       "      <td>4100</td>\n",
       "      <td>出租 荣丰2008 1室 北 简装修</td>\n",
       "      <td>170.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>西城广安门玺源台·承玺</td>\n",
       "      <td>32㎡</td>\n",
       "      <td>5800</td>\n",
       "      <td>出租 玺源台·承玺 1室 南向 简装修</td>\n",
       "      <td>181.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>海淀万柳光大水墨风景</td>\n",
       "      <td>97㎡</td>\n",
       "      <td>18000</td>\n",
       "      <td>万柳商圈,光大水墨风景,万城小华府之称的品质小区,全南两居室</td>\n",
       "      <td>185.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>海淀公主坟国悦府</td>\n",
       "      <td>96㎡</td>\n",
       "      <td>19000</td>\n",
       "      <td>国悦府 1室1厅1卫 带飘窗 经典实用</td>\n",
       "      <td>197.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>西城牛街牛街西里二区</td>\n",
       "      <td>55㎡</td>\n",
       "      <td>14000</td>\n",
       "      <td>新出牛街西里二区 3室 精装修+有电梯+近地铁+超市</td>\n",
       "      <td>254.55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 70
  },
  {
   "metadata": {},
   "cell_type": "code",
   "outputs": [],
   "execution_count": null,
   "source": "",
   "id": "eb175fa59efff56d"
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
